CREATE EXTERNAL TABLE jms_dm.dm_mng_explosion_warehouse_difficult_network_dt
(
    final_sign_network_code string COMMENT '最终签收派件网点编码',
    final_sign_network_name string COMMENT '最终签收派件网点编码',
    end_agent_code          string COMMENT '末端网点所属代理区编码',
    end_agent_name          string COMMENT '末端网点所属代理区名称',
    need_sign_count_1d      int COMMENT '1天应签收',
    retention_count_1d      int COMMENT '1天内滞留',
    need_sign_count_2d      int COMMENT '2天应签收',
    retention_count_2d      int COMMENT '2天内滞留',
    need_sign_count_3d      int COMMENT '3天应签收',
    retention_count_3d      int COMMENT '3天内滞留',
    need_sign_count_5d      int COMMENT '5天应签收',
    retention_count_5d      int COMMENT '5天内滞留',
    need_sign_count_7d      int COMMENT '7天应签收',
    retention_count_7d      int COMMENT '7天内滞留',
    scan_sum                int COMMENT '时效签收量',
    staff_code              string COMMENT '员工编码',
    staff_name              string COMMENT '员工名称',
    position_name           string COMMENT '岗位名称',
    is_warn                 int COMMENT '是否预警,全为1',
    final_plan_sign_date    string COMMENT '规划签收日期',
    agent_type              string COMMENT '虚拟代理区,代理区',
    virt_code               string COMMENT '虚拟代理区code',
    virt_name               string COMMENT '虚拟代理区name',
    end_provider_id         string COMMENT '末端网点所属省份id',
    end_provider_name       string COMMENT '末端网点所属省份名称',
    end_city_id             string COMMENT '末端网点所属城市id',
    end_city_name           string COMMENT '末端网点所属城市名称',
    district_code           string COMMENT '转单责任网点片区code',
    district_desc           string COMMENT '转单责任网点片区desc',
    district_id             string COMMENT '转单责任网点片区id',
    duration                string COMMENT '60天内持续天数',
    area_code               string COMMENT '区域code',
    area_name               string COMMENT '区域名字',
    1pressure               decimal(16, 4) COMMENT '1日内压力值',
    3pressure               decimal(16, 4) COMMENT '3日内压力值',
    5pressure               decimal(16, 4) COMMENT '5日内压力值',
    7pressure               decimal(16, 4) COMMENT '7日内压力值',
    1frame                  int COMMENT '1日内票量',
    3frame                  int COMMENT '3日内票量',
    5frame                  int COMMENT '5日内票量',
    7frame                  int COMMENT '7日内票量'
)
    COMMENT '问题件网点滞留预警小汇总'
    PARTITIONED BY (
        dt string COMMENT '规划签收日期')
    STORED AS parquet
    LOCATION
        '/dw/hive/jms_dm.db/external/dm_mng_explosion_warehouse_network_dt'